select @nextDecision:=NotificationTypeId from NotificationType where Name='NextDecision';
select @nextNotification:=NotificationTypeId from NotificationType where Name='NextNotification';
select @decisionAfterReturn:=NotificationTypeId from NotificationType where Name='DecisionAfterReturn';
select @notificationAfterReturn:=NotificationTypeId from NotificationType where Name='NotificationAfterReturn';
select @finalization:=NotificationTypeId from NotificationType where Name='Finalization';
select @returnToDraftDueToDecision:=NotificationTypeId from NotificationType where Name='ReturnToDraftDueToDecision';
select @returnToDraftDueToRouteChange:=NotificationTypeId from NotificationType where Name='ReturnToDraftDueToRouteChange';
select @acquaitanceRequest:=NotificationTypeId from NotificationType where Name='AcquaintanceRequest';


insert into usernotification (DocCard, NotificationType, DcUser, NotificationTime, Text, UserNote, LastActionUser, RoutePointNum)
	Values (@docCard1, @nextDecision, @docCircUser1, '2007-06-07 9:55', 'pass docCard1', 'Hi1', @docCircAdmin, 1);

set @user1Notif1:=last_insert_id();
	
insert into usernotification (DocCard, NotificationType, DcUser, NotificationTime, Text, UserNote, LastActionUser, RoutePointNum)
	Values (@docCard1, @finalization, @docCircUser1, '2007-06-07 9:56', 'docCard1 finalized', 'Hi2', @docCircAdmin, 2);

set @user1Notif2:=last_insert_id();

insert into usernotification (DocCard, NotificationType, DcUser, NotificationTime, Text, UserNote, LastActionUser, RoutePointNum)
	Values (@docCard2, @acquaitanceRequest, @docCircUser1, '2007-06-07 9:58', 'check docCard1', 'Hi3', null, 3);
	
set @user1Notif3:=last_insert_id();

insert into usernotification (DocCard, NotificationType, DcUser, NotificationTime, Text, UserNote, LastActionUser, RoutePointNum)
	Values (@docCard2, @nextNotification, @docCircUser2, '2007-06-07 9:57', 'see docCard2', 'Hi4', @docCircUser1, 4);
	
set @user2Notif1:=last_insert_id();
